SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GO
CREATE PROCEDURE [dbo].[paCertificaObtenerAgente]
-- < Registro de Actualizaciones >
-- 21-11-2006 
-- 23-11-2006


	@Documento INT,
	@IdAgenteEncontrado INT OUTPUT,
	@ApellidoyNombreEncontrado VARCHAR(100) OUTPUT

	
AS
SET NOCOUNT ON
SET DATEFORMAT DMY
SELECT @IDAgenteEncontrado = IdAgente , @ApellidoyNombreEncontrado = RTRIM(LTRIM(Apellido))+', '+RTRIM(LTRIM(Nombre)) FROM Tb_Agentes WHERE Documento = @Documento

RETURN
GO
GRANT EXECUTE ON  [dbo].[paCertificaObtenerAgente] TO [Certificaciones]
GRANT EXECUTE ON  [dbo].[paCertificaObtenerAgente] TO [CertificacionesAdministracion]
GRANT EXECUTE ON  [dbo].[paCertificaObtenerAgente] TO [SoloVer]
GO
